package com.lmh.mapper;

import com.lmh.bean.OfflineAnalyticTemplate;
import org.apache.ibatis.annotations.*;

/**
 * @program bigdata-service
 * @Description 大数据分析业务数据库交互
 * @Author limeihua
 * @Date 2024/08/04 23:21
 * @Version 1.0
 */
@Mapper
public interface OfflineAnalyticMapper {
    @Select("SELECT id, sql_id, sql_content, create_time, update_time, execution_params FROM bigdata.offline_analysis_template_sql_table WHERE sql_id = #{sqlID}")
    @Results({
            @Result(property = "id", column = "id"),
            @Result(property = "sqlID", column = "sql_id"),
            @Result(property = "sqlContent", column = "sql_content"),
            @Result(property = "createTime", column = "create_time"),
            @Result(property = "updateTime", column = "update_time"),
            @Result(property = "executionParams", column = "execution_params"),
    })
    OfflineAnalyticTemplate getSqlContent(String sqlID);
}




